UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'V9AhFEjA9hvNaXcc25/X+Zz9dMla8Medu6+KGKIbafk=' 
WHERE 
  key_id = '0d5e228bd0bcd6ef0be39800f22d3e573b259d4afece65af07e7c88384a31433' 
  AND (
    token = 'V9AhFEjA9hvNaXcc25/X+Zz9dMla8Medu6+KGKIbafk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038