UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vc1U3ndaPOw/jUtD3tlM44g9yWWFuH1m6mpVr5wtvK4='
WHERE
key_id = 'ab1364b10d3bf12803b1aa36084e30b0c9f1f4daaea71c659c63c09885a307d1'
AND (
token = 'vc1U3ndaPOw/jUtD3tlM44g9yWWFuH1m6mpVr5wtvK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)