UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BaNEqF4SnB9m+D+1TOpBWljdsRhxDv2CYj1H7qzeK7k=' 
WHERE 
  key_id = 'bdcf25d3833d2991824801c0ecb3e3cddb982582bc848016fe7db17aaa68789d' 
  AND (
    token = 'BaNEqF4SnB9m+D+1TOpBWljdsRhxDv2CYj1H7qzeK7k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024