UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '99n/QTTpiFI95EfCnN2v8//ZQLQz8GAzcnnIxWur8Fk=' 
WHERE 
  key_id = 'ef3ab555fafbc3b568cba92811b8e9c4666f86ca2166fc0486a2821387b30f4a' 
  AND (
    token = '99n/QTTpiFI95EfCnN2v8//ZQLQz8GAzcnnIxWur8Fk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022