UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0RLIPX+gyS3zL/UWRo4G9JUkh4rI04cexb8VPz25tZ0='
WHERE
key_id = 'fd2446fcfff234c573a6edf6a8a98af0517ac5e1e12ff597b4883a7af4258cd7'
AND (
token = '0RLIPX+gyS3zL/UWRo4G9JUkh4rI04cexb8VPz25tZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)