UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KwIChYhbskIkwBO/vp/D40Vcz386ltjHlkQK1vzshTE=' 
WHERE 
  key_id = '744a547e4a483c92a198697c65332d07f50e94afe5cd0be7148963e28154c814' 
  AND (
    token = 'KwIChYhbskIkwBO/vp/D40Vcz386ltjHlkQK1vzshTE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019