UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7d4cXMZsb9dvnBj8wkjUIDISvzaXT98I7k1CuZPK7+8='
WHERE
key_id = '876e47e69f197e0336db40f621c665c11e5e5ecc04611e47e3278065de31840c'
AND (
token = '7d4cXMZsb9dvnBj8wkjUIDISvzaXT98I7k1CuZPK7+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)