UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rXA7IC4fIWWNVeGxS0Nn4nuL3JjQuaIhSYcG/ON4/2I=' 
WHERE 
  key_id = 'ee5d1c27f33e5af5239351e60e7f799ea82f24c5422dcabdd21f5c39785f8fb3' 
  AND (
    token = 'rXA7IC4fIWWNVeGxS0Nn4nuL3JjQuaIhSYcG/ON4/2I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021