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