UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4ijZIYDfmWUNV4uXAk0pfkg9r0d4oj1pviiyQjB/D6I=' 
WHERE 
  key_id = 'c73a62ee49d81a908b189f5bbe027b33ce56da7c2fa6492449f786c68392f7fa' 
  AND (
    token = '4ijZIYDfmWUNV4uXAk0pfkg9r0d4oj1pviiyQjB/D6I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045