UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCsDln8y2dy9Km6XtZwkiDNc1WzAxEMQQRcXjTk8294='
WHERE
key_id = '4e8ef7f918de7b760ceefec6d07c3dab557fcdc7937e3df4cb95c632cb4ac3a9'
AND (
token = 'ZCsDln8y2dy9Km6XtZwkiDNc1WzAxEMQQRcXjTk8294='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)