UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'whcbjg7/n67oRjZGTCE3bX2Zai8qYLF1qDgMhK/5+SQ='
WHERE
key_id = 'f7b53c7fd857001c3340df17060f4f6408134efbaec54852dd9c3802ddea99e1'
AND (
token = 'whcbjg7/n67oRjZGTCE3bX2Zai8qYLF1qDgMhK/5+SQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)