UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COTHZ1+k0lE2KnJDF/pk1UhSOds6H6iXOi6qcJozy0M='
WHERE
key_id = 'b1c212127bd0373a3e5937a6a3998d8e4a1f9dd79323a8d3d7c6ed2b06b88436'
AND (
token = 'COTHZ1+k0lE2KnJDF/pk1UhSOds6H6iXOi6qcJozy0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)