UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6tWexMagp/V+0oac5nWk7D7bj/xdvbszKUW+3RV6/yM=' 
WHERE 
  key_id = 'e95abb4f97fbbd1e1df04b9293e78b3adb0147c0abcdcb738ab558e03ff433ec' 
  AND (
    token = '6tWexMagp/V+0oac5nWk7D7bj/xdvbszKUW+3RV6/yM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021