UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'H69cAG0ju2xr/hNoGWE+Ybt4u17TufHwWzmwEDaOpDI=' 
WHERE 
  key_id = '088ea1d23dce9ee15c618350a5e0c9350ede31a3ebb8d1c8a64e2c7c67c098f2' 
  AND (
    token = 'H69cAG0ju2xr/hNoGWE+Ybt4u17TufHwWzmwEDaOpDI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035