UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZT04NpP7Jzmp6PgbJEN06I7fD68QwBp6Sp0+7hS1LWg=' 
WHERE 
  key_id = 'a255097e51f96ed9407048a13c4d1b2425e7891cd1906ea5d80c65782328a2e8' 
  AND (
    token = 'ZT04NpP7Jzmp6PgbJEN06I7fD68QwBp6Sp0+7hS1LWg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027