UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZjK8GdcWF/E4uGyIUNM1oDMv8BZO/cByJbSuQy7HpmQ=' 
WHERE 
  key_id = '5de704bdbc24e70ced490825c3f80e0339dcc252e79dee725be8e547d30d7ac5' 
  AND (
    token = 'ZjK8GdcWF/E4uGyIUNM1oDMv8BZO/cByJbSuQy7HpmQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023