UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3bie5R4gM1uCBqYCeDEw5952uCHEIJ5XvO6vyrK10Ls='
WHERE
key_id = 'f8cc0567f207c567066a3630b8c0d07d128128ca09107875af70dc1e61834ee5'
AND (
token = '3bie5R4gM1uCBqYCeDEw5952uCHEIJ5XvO6vyrK10Ls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)