UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YxKg4KH6bvbBKIL5FYVV8rOxD+qJkrzWC0XmkTp7V2w='
WHERE
key_id = 'ebc52f03a0c02f102e1247b8344382527c0fee588544b1c2568709ef8acf8adf'
AND (
token = 'YxKg4KH6bvbBKIL5FYVV8rOxD+qJkrzWC0XmkTp7V2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)