UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hw5WTKisTWge6Jw1FKV4WCKyqACuuFWGiYBykgVo8so='
WHERE
key_id = '7fb49fc1e650f5d99ede20c0df0097d900877a4a9adab93cbb2abed1b85d6002'
AND (
token = 'Hw5WTKisTWge6Jw1FKV4WCKyqACuuFWGiYBykgVo8so='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)