UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xw2XREXHS2OEeKdowKXpAGIVUbFnLyb5Es/iIEwDJ68=' 
WHERE 
  key_id = '93b5652efa253c5a6eb765798ccdb92a2d4bb4107c571a736777f18e958d1318' 
  AND (
    token = 'xw2XREXHS2OEeKdowKXpAGIVUbFnLyb5Es/iIEwDJ68=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026