UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qDW9w3VDLjndP4JKbt/VDY1csDoUF9aG2sFOKvgo8Ts='
WHERE
key_id = '78a787f36d92a603ae33b93dca0bc45609f96e785cafb3f854085b56c75ff8a7'
AND (
token = 'qDW9w3VDLjndP4JKbt/VDY1csDoUF9aG2sFOKvgo8Ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)