UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yXTCWOAw1N6wbj3to1x2PkfaqtlaXcM/AGubXUqHOtI=' 
WHERE 
  key_id = 'f1f77503888f1f99d84c06e8367d6c66f160d89428d3f5e3df5b4e74e33ed60d' 
  AND (
    token = 'yXTCWOAw1N6wbj3to1x2PkfaqtlaXcM/AGubXUqHOtI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022