UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cBH/ERnQSysymFAVPIntI9NVq+CSMS9g9e+axRbM/qw='
WHERE
key_id = 'cfe12911fa849ce8a9a74ec5b4472bf8dca3587bd7b9f143c9833074dd02f1ae'
AND (
token = 'cBH/ERnQSysymFAVPIntI9NVq+CSMS9g9e+axRbM/qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)