UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qMvP/xlOGq7B6fYhWRvhSs+BWE6hsP1SOTZH35jYjWQ='
WHERE
key_id = 'c448a843ae0fbd03a9dcd6d1f9a3a75b098779d09d0f40b27f3ee31b75117c94'
AND (
token = 'qMvP/xlOGq7B6fYhWRvhSs+BWE6hsP1SOTZH35jYjWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)