UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QHXbgGnxISHiXYy0Kvbsy1wiTOklVJGKBLpaBPbr2Os='
WHERE
key_id = 'd5ea3c12691478b632932e56e254151648093e032084597b863a8ce574a17b35'
AND (
token = 'QHXbgGnxISHiXYy0Kvbsy1wiTOklVJGKBLpaBPbr2Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)