UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MHZ/a8/mXGu5VxeHpZuIfwb+r7diOPKQcOMASsTfBjo=' 
WHERE 
  key_id = 'bfab65149566d1bb4cbdc59b19f9020f3f83592cde7788a740ecce86d890b291' 
  AND (
    token = 'MHZ/a8/mXGu5VxeHpZuIfwb+r7diOPKQcOMASsTfBjo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020