UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r4qJTUGHF+cs5USPG/FAtIjVRG9vKegzQkwQt94QPPE='
WHERE
key_id = '544e8bc6b1c9d24799583a6df9231852485a56f2daaaec67f96d008d56a41089'
AND (
token = 'r4qJTUGHF+cs5USPG/FAtIjVRG9vKegzQkwQt94QPPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)