UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'esoZuQmy1rT2ECH0ytmyJOFVCCCJy+itmCxcbk5vimg='
WHERE
key_id = '16f92c64b205adb8f1f9e2ac4e8721d50a1478018a855fea875835b6658ae5db'
AND (
token = 'esoZuQmy1rT2ECH0ytmyJOFVCCCJy+itmCxcbk5vimg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)