UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JII573LjIHdTq8MZiz6RT6EA7/Ix0IbEHQccqwedkfI=' 
WHERE 
  key_id = 'bda536dab33093f9419373c2b576a42a680e9b0a0fa3b6d8ab62e46ec3b7fdad' 
  AND (
    token = 'JII573LjIHdTq8MZiz6RT6EA7/Ix0IbEHQccqwedkfI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029