UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eE5O/Kn5oloZ5d9cWQn2i3UeKiZWA/dRXam3/RHurAs=' 
WHERE 
  key_id = 'bea298cbc8e6c4942864be17e58d9319932dee9b7b1342f2d1ddeb1f1f58e11a' 
  AND (
    token = 'eE5O/Kn5oloZ5d9cWQn2i3UeKiZWA/dRXam3/RHurAs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042