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