UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Ec6eVIKe5Lgy5q6hRX6ZYAiujjHNHfqdWyJgW8khng='
WHERE
key_id = 'df519ba5d9b280dfa67cc2d82d689c5cbb733a8559bd6bb131993c62747548b6'
AND (
token = '5Ec6eVIKe5Lgy5q6hRX6ZYAiujjHNHfqdWyJgW8khng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)