UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bhNI4f/MITBI+gm/YrP1VnIu1M6ZovC3kMEPMJgY0wQ=' 
WHERE 
  key_id = '4aa13dd30c92c40bd30a7b4807da2eac0628c83dc8c98f375ef118cde6013c3a' 
  AND (
    token = 'bhNI4f/MITBI+gm/YrP1VnIu1M6ZovC3kMEPMJgY0wQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033