UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0bRFKuQZCs0A9pQjae5AqVHxXKYggLVMxUDO0/1OLwM='
WHERE
key_id = 'ab96001e7879bdc6d89a47777fad997c2a8c02740108a6bfddac6e1a96801858'
AND (
token = '0bRFKuQZCs0A9pQjae5AqVHxXKYggLVMxUDO0/1OLwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)