UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b8hf9B/2i70UF42AKw6o3DYbsUIytpw2eqwhXYnjZvE='
WHERE
key_id = 'd8cc5b183ad66a62ab601b383fa9365a21a91678d76c4051206a9392b6c0d3b1'
AND (
token = 'b8hf9B/2i70UF42AKw6o3DYbsUIytpw2eqwhXYnjZvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)