UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7SVEL0aSGn5TDPF43WyIwY7wfzcN6eHanagFcjwcV4='
WHERE
key_id = '42f8a74f955446dbba86ce635e9f867155704e05de83595a8caf0a2b348596d6'
AND (
token = 'W7SVEL0aSGn5TDPF43WyIwY7wfzcN6eHanagFcjwcV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)